Computer Science Lesson Plan
Class: 5 - Lesson: 6 Spreadsheet (Basics of Spreadsheet and Properties of Cells)

Purpose: To learn about basics of spreadsheet such as rows, columns, cells and cell addresses,editing operations and properties of cells in a spreadsheet.

No. of Classes

One class.

Material Required

OpenOffice (Spreadsheet).

Curriculum Content
  • 7) Open office - Spread sheet
  • 7.1) Spread sheet basics
  • 7.2) Cell properties
  • 7.2.4) Cell border
  • 7.2.19) Autofill
  • 7.2.20) Rename Sheet
    •

    Prior Knowledge

    Students should know:

  • How to create a table in an OpenOffice text document.
  • How to open and save a file.

    • Exercise

    Exercise 1


    1. What is a spreadsheet? Explain the uses of spreadsheets.

    Exercise 2


    1. Insert a new sheet, delete sheet2, and rename sheet3.

    Exercise 3


    1. Copy an image, paste it into a new spreadsheet file, and save the file.

    Exercise 4


    1. Change the cell colour of the following cells as specified: D13 to green, G18 to red, and J7 to violet.

    No Image

    Solution


  • Link to view the solution video for Exercises 1 and 2.
  • Link to view the solution video for Exercise 3.
  • Link to view the solution video for Exercise 4.

    • Teacher Instructions
    1. Ensure that students practise all the features.
    2. Explain row numbers and column names in a spreadsheet.
    3. Differentiate between spreadsheets and text documents.
    4. Explain the autofill feature and its use in filling dates, days and serial numbers.
    5. Help them understand inserting, moving and renaming a sheet.
    6. While teaching, use the terms row, column, cell, sheet, etc., so that students become familiar with them.
    7. Teach all the basic properties of a cell.
    8. Teachers may allow students to complete the exercise in groups.